package com.dingding.service.share.sql;

public class ShareActivitySql {
	
	//获取某个活动所有礼品的sql
	public static final String GET_ACTIVITY_GIFTS = "SELECT ag.giftId,ag.giftName,a_g.totalNumber,a_g.residualNumber FROM activityrefgift a_g " +
			"INNER JOIN activity ac ON ac.snId = a_g.acId " +
			"INNER JOIN activitygift ag ON a_g.giftId = ag.giftId " +
			"WHERE ac.snId = ?";
	
	//获取活动礼品详情的sql
	public static final String GET_ACTIVITY_GIFT_DETAIL = "SELECT ag.giftId,ag.giftName,a_g.totalNumber,a_g.residualNumber FROM activityrefgift a_g " +
			"INNER JOIN activity ac ON ac.snId = a_g.acId " +
			"INNER JOIN activitygift ag ON a_g.giftId = ag.giftId " +
			"WHERE ac.snId = ? AND ag.giftId = ?";
}
